<?php
$type = @$_GET['type'];

switch ($type) {
    case 'thematic':
        $category_id = @$_GET['id'];
        $where_condition = (is_numeric($category_id))? "WHERE `a`.`category_id` = '$category_id'":"";
        $query = "SELECT `a`.*, `b`.`category_name` as thematic_area, `c`.`category_name` as sub_thematic_area, `d`.`location_name` FROM (`tbl_publication_info` as a) JOIN `tbl_publication_category` as b ON `a`.`category_id` = `b`.`id` LEFT JOIN `tbl_publication_category` as c ON `a`.`sub_category_id` = `c`.`id` LEFT JOIN `tbl_locations` as d ON `a`.`location` = `d`.`id` $where_condition ORDER BY `a`.`id` DESC";
        break;
     case 'publication':
        $publication_id = @$_GET['id'];
        $query = "SELECT `a`.*, `b`.`category_name` as thematic_area, `c`.`category_name` as sub_thematic_area FROM (`tbl_publication_info` as a) JOIN `tbl_publication_category` as b ON `a`.`category_id` = `b`.`id` LEFT JOIN `tbl_publication_category` as c ON `a`.`sub_category_id` = `c`.`id` WHERE `a`.`id` = '$publication_id' ";
         break;
    default:
        die("Please check the URL carefully and try again.");
        break;
}
define('BASEPATH',"TEMP");
require_once('../../system/application/config/database.php');
require_once('../../system/application/config/config.php');

require_once('../config/lang/eng.php');
require_once('../tcpdf.php');
//echo $config['publication_images_path'];exit;
$image_path = $config['publication_images_path'];
$image_path_abs = $config['publication_images_path_abs'];
$con = mysql_connect($db['default']['hostname'],$db['default']['username'],$db['default']['password']);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db($db['default']['database'], $con);

$result = mysql_query($query);
$publications = array();
while($row = mysql_fetch_assoc($result))
{
    $publications[] = $row;
}
mysql_close($con);
//echo "<pre>";print_r($publications);
//echo "</pre>";
//exit;


$header_logo = PDF_HEADER_LOGO;
$today = date("l, dS F Y H:i");
$header_logo_width = PDF_HEADER_LOGO_WIDTH;
$header_title = PDF_HEADER_TITLE;
$header_string= "Last modified: $today"; //PDF_HEADER_STRING
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Subin Maharjan');
$pdf->SetTitle('UN Habitat Title');
$pdf->SetSubject('Report on publication of UN Habitat');
$pdf->SetKeywords('Report, PDF, UN Habitat, guide');

// set default header data
$pdf->SetHeaderData($header_logo, $header_logo_width, $header_title, $header_string);

// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

//set some language-dependent strings
$pdf->setLanguageArray($l);

// ---------------------------------------------------------
// set font
$pdf->SetFont('helvetica', '', 10);
$pdf->setJPEGQuality(75);

foreach($publications as $publication){
    $title = ($publication['title']!="")?"<h2>".$publication['title']."</h2>": "";
    $code = ($publication['coding']!="")?"<b>Code:</b> ".$publication['coding']."<br>": "";
    $thematic_area = ($publication['thematic_area']!="")?"<b>Thematic Area:</b> ".$publication['thematic_area']."<br>": "";
    $sub_thematic_area = ($publication['sub_thematic_area']!="")?"<b>Sub Thematic Area:</b> ".$publication['sub_thematic_area']."<br>": "";
    $publisher = ($publication['publisher']!="")?"<b>Publisher:</b> ".$publication['publisher']."<br>": "";
    $no_of_page = ($publication['pages']!="")?"<b>Number of Pages:</b> ".$publication['pages']."<br>": "";
    $year_of_publication = ($publication['publish_year']!="")?"<b>Year of Publication:</b> ".$publication['publish_year']."<br>": "";
    $isbn_no = ($publication['isbn_number']!="")?"<b>ISBN number:</b> ".$publication['isbn_number']."<br>": "";
    $abstract = ($publication['abstract']!="")?"<b>Abstract:</b> ".$publication['abstract']."<br>": "";
    $country = ($publication['country']!="")?"<b>Country:</b> ".$publication['country']."<br>": "";
    $post_image = $publication['image'];
    $image =$image_path.$post_image;
    $image_abs=$image_path_abs.$post_image;
//    echo $image;
//    echo($image_abs)."<br>";
if (!is_array(@getimagesize($image_abs))){
    $image = '../images/image_demo.jpg';
}
//die($image);
// add a page
$pdf->AddPage();
$html = <<<EOF
<!-- EXAMPLE OF CSS STYLE -->
<style>
	h1 {
		color: navy;
		font-family: times;
		font-size: 24pt;
		text-decoration: underline;
	}
	p.first {
		color: #003300;
		font-family: helvetica;
		font-size: 12pt;
	}
	p.first span {
		color: #006600;
		font-style: italic;
	}
	p#second {
		color: rgb(00,63,127);
		font-family: times;
		font-size: 12pt;
		text-align: justify;
	}
	p#second > span {
		background-color: #FFFFAA;
	}
	
	div.test {
		color: #CC0000;
		background-color: #FFFF66;
		font-family: helvetica;
		font-size: 10pt;
		border-style: solid solid solid solid;
		border-width: 2px 2px 2px 2px;
		border-color: green #FF00FF blue red;
		text-align: center;
	}
</style>
<table class="" cellpadding="0" cellspacing="0">
 <tr>
  <td width="35%" rowspan = "" align=""></td>
  <td width="65%" align="left">
$title
$code
$thematic_area
$sub_thematic_area
$publisher
$no_of_page
$year_of_publication
$isbn_no
$country
$abstract
</td>
 </tr>
</table>
EOF;
// Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false)
$pdf->Image($image, 15, 28, 55, 0, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
// output the HTML content
$pdf->writeHTML($html, true, false, true, false, '');

}
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

// *******************************************************************
// HTML TIPS & TRICKS
// *******************************************************************

// REMOVE CELL PADDING
//
// $pdf->SetCellPadding(0);
//
// This is used to remove any additional vertical space inside a
// single cell of text.

// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

// REMOVE TAG TOP AND BOTTOM MARGINS
//
// $tagvs = array('p' => array(0 => array('h' => 0, 'n' => 0), 1 => array('h' => 0, 'n' => 0)));
// $pdf->setHtmlVSpace($tagvs);
//
// Since the CSS margin command is not yet implemented on TCPDF, you
// need to set the spacing of block tags using the following method.

// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

// SET LINE HEIGHT
//
// $pdf->setCellHeightRatio(1.25);
//
// You can use the following method to fine tune the line height
// (the number is a percentage relative to font height).

// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

// CHANGE THE PIXEL CONVERSION RATIO
//
// $pdf->setImageScale(0.47);
//
// This is used to adjust the conversion ratio between pixels and
// document units. Increase the value to get smaller objects.
// Since you are using pixel unit, this method is important to set the
// right zoom factor.
//
// Suppose that you want to print a web page larger 1024 pixels to
// fill all the available page width.
// An A4 page is larger 210mm equivalent to 8.268 inches, if you
// subtract 13mm (0.512") of margins for each side, the remaining
// space is 184mm (7.244 inches).
// The default resolution for a PDF document is 300 DPI (dots per
// inch), so you have 7.244 * 300 = 2173.2 dots (this is the maximum
// number of points you can print at 300 DPI for the given width).
// The conversion ratio is approximatively 1024 / 2173.2 = 0.47 px/dots
// If the web page is larger 1280 pixels, on the same A4 page the
// conversion ratio to use is 1280 / 2173.2 = 0.59 pixels/dots

// *******************************************************************

// reset pointer to the last page
$pdf->lastPage();

// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$date = date('d-F-Y');
$pdf->Output($type."_".$date.'.pdf', 'I');

//============================================================+
// END OF FILE
//============================================================+
